Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SUBPART_COL_STATISTICS

`ALL_SUBPART_COL_STATISTICS` describes column statistics and histogram information for subpartitions of partitioned objects accessible to the current user.

Related Views

- `DBA_SUBPART_COL_STATISTICS` provides this information for all subpartitions in the database.

- `USER_SUBPART_COL_STATISTICS` provides this information for subpartitions of all partitioned objects owned by the current user. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner name
`TABLE_NAME` | `VARCHAR2(30)` | `NOT NULL` | Table name
`SUBPARTITION_NAME` | `VARCHAR2(30)` |  | Table subpartition name
`COLUMN_NAME` | `VARCHAR2(4000)` |  | Column name
`NUM_DISTINCT` | `NUMBER` |  | Number of distinct values in the column
`LOW_VALUE` | `RAW(32)` |  | Low value in the column
`HIGH_VALUE` | `RAW(32)` |  | High value in the column
`DENSITY` | `NUMBER` |  | Density of the column
`NUM_NULLS` | `NUMBER` |  | Number of nulls in the column
`NUM_BUCKETS` | `NUMBER` |  | Number of buckets in histogram for the column
`SAMPLE_SIZE` | `NUMBER` |  | Sample size used in analyzing this column
`LAST_ANALYZED` | `DATE` |  | Date on which this column was most recently analyzed
`GLOBAL_STATS` | `VARCHAR2(3)` |  | Indicates whether column statistics for the subpartition were collected by analyzing the table as a whole (`YES`) or estimated from statistics gathered on partitions and subpartitions (`NO`)
`USER_STATS` | `VARCHAR2(3)` |  | Indicates whether statistics were entered directly by the user (`YES`) or not (`NO`)
`AVG_COL_LEN` | `NUMBER` |  | Average length of the column (in bytes)
`HISTOGRAM` | `VARCHAR2(15)` |  | Indicates existence/type of histogram: `NONE` `FREQUENCY` `HEIGHT BALANCED`